SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001120s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 150034 LIMIT 1 [ RunTime:0.000321s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 150034 [ RunTime:0.003508s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (103980,1035596,138168,850796,598278,1016045,1028261,863768,516354,699114,443239,186848,638587,105066,35006,512241,859705,361720,404220,48991,682515,101692,1038375,847901,406684,325896,237978,307675,572055,583159,273668,195272,334724,941219,297776,1000166,1036152,505461,134221,168486,385148,931239,12900,1041846,814121,892414,269776,413353,915001,454213,383618,510704,280379,474417,619978,640547,737640,652187,134433,841944) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001195s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 150034 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001350s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 150034 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000516s ]