SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001320s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 144830 LIMIT 1 [ RunTime:0.000315s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 144830 [ RunTime:0.001506s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (627831,1041611,128547,408168,157255,345366,190885,32941,938939,355992,609840,373721,430499,507403,386240,325232,816863,426561,1003065,448514,381276,611262,357583,643746,416835,678125,340039,1002340,738443,907022,145907,929463,85371,524501,1788,267746,1045777,90359,608904,844758,42162,850027,151451,651584,741163,292191,831002,71500,905344,796463,1030422,592242,996000,234638,553282,515193,976700,376493,979012,69425) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001091s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 144830 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 144830 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000593s ]