SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001278s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1039389 LIMIT 1 [ RunTime:0.000488s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1039389 [ RunTime:0.001602s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (300442,208188,166250,88783,599356,1022386,197538,10770,462312,52390,139402,398556,1042481,1048920,831441,717703,794257,9508,1009313,36020,315172,890234,975756,268300,238818,50172,391930,400321,636653,1043508,393668,781076,200522,629824,905924,622598,352939,1016243,467003,401129,989583,159803,561172,619102,615999,1024636,23013,395931,538665,1015090,64383,1020395,910665,259447,821482,760343,288061,31103,581122,2742) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001084s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1039389 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000353s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1039389 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000567s ]