SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001333s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1020690 LIMIT 1 [ RunTime:0.005942s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1020690 [ RunTime:0.001780s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (408654,692056,386972,305367,833460,472904,430067,58572,14184,982049,214299,1034816,219154,670539,569591,255998,778552,617002,170442,994467,233301,138860,329698,375191,106690,290269,512946,338871,389870,213971,373173,60817,65264,745873,679711,397813,418657,582110,12685,453186,635365,313014,172061,140220,753340,451390,266052,428622,66300,382526,606057,549685,655446,96888,772298,376134,669209,22929,494726,27171) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1020690 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000389s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1020690 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]