SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402663 LIMIT 1 [ RunTime:0.000397s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402663 [ RunTime:0.001949s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (71883,617037,58197,926915,970471,1044531,195379,52188,568743,901826,713399,171710,832553,114214,982177,568405,213852,129583,580054,101439,610274,568234,347479,924735,772210,886190,338839,752182,791674,350740,426724,206877,545834,694132,409737,717010,687136,214259,573002,352142,521873,106642,406766,749377,207241,369419,689067,71772,702775,864059,733961,1036534,575863,526328,390203,536216,88370,653902,57337,597150) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402663 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000665s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402663 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000587s ]