SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001192s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 570941 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 570941 [ RunTime:0.001648s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1035124,701090,64160,501992,846710,391842,631776,174027,569213,348888,332920,749067,206516,516302,841769,994551,840503,441072,266596,894418,264516,1045529,123860,851156,1006642,564453,798811,863817,711037,544149,101668,150752,281385,483734,483193,693209,148554,958528,456622,307421,400132,156089,557454,1044842,222113,640857,771127,414080,74818,898893,953896,638373,996293,763612,645844,120659,382234,158414,20261,706142) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001107s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 570941 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000588s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 570941 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000524s ]