SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001176s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1018167 LIMIT 1 [ RunTime:0.002064s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1018167 [ RunTime:0.001600s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (899215,962492,50665,324230,413334,102781,258271,102238,878906,223516,256566,358047,859156,654956,744196,242844,746886,15564,549408,175826,857497,1032978,645231,74156,46491,267196,947365,973124,1032422,1041201,76051,1026673,702561,145076,795188,737188,528350,808558,1034097,43911,770973,523487,273041,540219,999283,985823,393348,3777,902140,648903,258337,121955,1001222,375677,520367,868446,219414,937199,532309,363344) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001144s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1018167 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000591s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1018167 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000784s ]