SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001345s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 561990 LIMIT 1 [ RunTime:0.000410s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 561990 [ RunTime:0.002457s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (885914,78799,696487,990873,548888,118864,702596,526819,38086,224645,328732,404274,422508,397045,914898,599251,622874,222222,531688,1015906,309135,192738,1039607,109591,739872,1037350,714443,762657,707028,737609,507886,745442,445388,840756,102946,685586,737159,715301,929476,817294,689195,296911,164306,258168,523939,451877,1007311,25894,77952,74784,163323,730245,889372,121060,122251,1040705,323922,723067,378124,889459) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 561990 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000461s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 561990 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]