SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001735s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 419499 LIMIT 1 [ RunTime:0.000789s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 419499 [ RunTime:0.002792s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1000440,314743,753855,979230,110137,302494,2564,428237,696989,30791,312762,195118,81477,833326,254799,158877,778328,704530,742129,932449,832775,828979,378755,176634,594755,940231,124195,678374,845671,968224,591113,532607,990215,819808,319201,424001,128988,351681,783514,1022278,274767,448242,108399,142487,857051,866603,387684,710602,531037,349832,898006,991154,53776,793630,771183,66542,326626,739363,875841,644410) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 419499 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 419499 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002596s ]