SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 402940 LIMIT 1 [ RunTime:0.000381s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 402940 [ RunTime:0.003066s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425097,682487,428722,647874,454964,888641,135159,795777,823154,504069,519301,116086,995021,505131,43228,286433,895837,101006,130435,600248,98700,828414,66489,40731,901620,561537,894093,895527,746827,870251,956164,333819,784246,655279,470153,513745,228370,858991,907823,926246,394261,373325,977855,421359,178318,383377,19353,470097,268649,443651,836475,635165,561979,751117,456218,999749,662867,145407,451572,65076) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.004470s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 402940 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000457s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 402940 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]