SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001151s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1013894 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1013894 [ RunTime:0.002040s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (547343,122386,503943,76564,678610,692208,321896,261550,171991,576936,551778,219481,854399,737254,431929,311294,224185,534279,479068,358025,793135,729236,225148,683068,247669,357173,944431,765887,292655,863269,875296,1006743,104140,850456,686793,890369,509789,201887,1029480,120429,887307,128361,432430,769605,1046007,189322,115520,984410,700545,311146,488691,85917,441586,596379,789635,223150,385941,131,433394,135284) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001134s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1013894 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000751s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1013894 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000615s ]