SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 505564 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 505564 [ RunTime:0.002979s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (485187,425196,680737,216742,564045,660820,68819,821114,434347,593390,235248,774185,900113,252557,907952,982666,769122,952903,769625,703612,177831,255603,393939,204707,185268,926587,405861,297528,622185,430439,616657,16839,77613,209952,98807,523050,582345,192134,822438,369048,312300,239223,582787,810246,217869,36633,693345,432632,210298,137384,904414,733989,905837,484734,348484,512885,125071,340298,888363,73912) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001071s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 505564 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000371s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 505564 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000528s ]