SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1009815 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1009815 [ RunTime:0.001914s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (86160,1005851,790716,75270,129548,107513,726164,957788,967556,462869,1008029,654162,43509,673838,398364,1044540,284978,149023,254745,1019165,602413,866756,937267,691862,735833,1030471,969143,129525,393669,370394,814784,750145,1011190,358664,524039,136762,228199,95088,665340,454254,317295,1022191,166755,590637,57939,565767,77352,685631,548034,349737,816022,705809,924471,231606,480701,116841,419119,790010,43497,152887) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1009815 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000447s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1009815 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]