SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 427554 LIMIT 1 [ RunTime:0.004169s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 427554 [ RunTime:0.002813s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (614979,975502,506793,396186,158731,881299,845485,903648,462409,64101,909571,701953,1032735,665264,1004023,87650,601519,199852,180204,539070,86319,315787,645650,870250,586867,994863,1027027,699366,35391,293155,336893,329347,170752,581035,564336,304823,37910,503846,32352,942583,433154,823295,608167,192768,462823,523183,103447,438748,518434,101966,4498,265707,348910,616097,1037317,122078,545271,790891,784774,732334) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 427554 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000549s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 427554 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000538s ]