SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.003234s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 28511 LIMIT 1 [ RunTime:0.000427s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 28511 [ RunTime:0.001983s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (65746,564993,1015819,480024,408555,696805,86017,491414,743210,265487,850097,576076,318963,352916,123452,120344,407766,249466,118024,211133,675891,734884,405168,871820,217266,937239,223328,259018,594035,914212,601836,116577,275708,315553,608221,670723,904704,555881,201028,282884,787801,182149,194603,726532,297701,984323,1014656,84259,869466,614464,758826,556048,103904,1019476,799897,1024597,681886,1047771,653283,878882) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.005390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 28511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000633s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 28511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001735s ]