SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001259s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 314518 LIMIT 1 [ RunTime:0.000307s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 314518 [ RunTime:0.001682s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (819143,347521,757916,833268,831360,430361,264851,487572,978873,252367,160204,170423,924587,511899,915381,107416,805513,663972,707769,47975,1037041,721852,202938,523953,3238,185057,487180,837693,860562,584895,929834,605017,318108,124006,161604,365817,644812,637035,422181,521833,112712,475804,355811,92719,150082,813538,132514,933354,989790,16930,776960,784265,983077,484803,219948,1019691,468580,306844,474603,293110) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001263s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 314518 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000512s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 314518 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]