SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001420s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 576243 LIMIT 1 [ RunTime:0.000371s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 576243 [ RunTime:0.004823s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (649068,458190,839296,450257,558993,281263,1042414,482886,639975,228535,69601,403563,1045938,500928,625741,199739,795656,659166,153242,231625,202707,971442,711572,706664,549311,408523,70702,222046,49408,868737,85160,34202,270140,23093,371215,104329,138398,750499,394901,746338,863694,128096,641013,512933,596596,161476,218139,936353,1034429,889621,652345,15092,485080,461703,586183,666056,856833,721308,980103,709059) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 576243 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000530s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 576243 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000631s ]