SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001159s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 432107 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 432107 [ RunTime:0.001924s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (278206,465588,173351,333841,282097,960773,117281,439088,530993,201799,187906,166362,1048509,1044481,102850,729372,93571,578486,1029113,49141,161816,136932,1042996,802471,696605,448474,192306,170401,1037016,345813,128035,787705,986806,131524,609544,456136,411790,1019186,726455,1037765,291219,427905,129698,491438,662812,142913,810794,541303,361403,384229,857874,688151,300538,104621,4848,144362,597631,748818,123888,694935) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001064s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 432107 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000424s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 432107 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000509s ]