SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001132s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 338819 LIMIT 1 [ RunTime:0.000326s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 338819 [ RunTime:0.002094s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1036942,307460,489448,293488,344412,701399,709744,54562,17467,1031924,101954,524983,957948,1025112,965077,952548,489016,510545,576940,1018411,713026,881265,97765,324570,604090,265867,397272,710577,844490,920025,523382,116273,951117,886674,515948,443769,140457,1046718,526681,111585,598424,821373,239874,608228,112926,47904,577061,896622,603653,549865,119316,241014,15224,349520,165305,258922,505994,703157,454002,1023801) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001477s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 338819 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000375s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 338819 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000595s ]