SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001125s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542516 LIMIT 1 [ RunTime:0.000383s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542516 [ RunTime:0.001723s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (76146,339447,1046955,421554,1029169,68041,19171,196651,708339,240863,50601,385047,284772,198182,177086,893575,1036610,338606,229432,94640,119367,476751,127002,81706,868056,230074,421972,509210,673575,476210,353596,1040476,781134,811338,697950,113782,572480,284528,5057,171511,123542,105886,404526,183201,42031,736084,993884,565879,844385,205663,348999,776287,247129,336936,775436,968451,61827,740378,162468,126760) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001013s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542516 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000492s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542516 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.003941s ]