SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001139s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 416068 LIMIT 1 [ RunTime:0.001292s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 416068 [ RunTime:0.001894s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (6592,1014345,366547,929630,348281,987991,460469,1023857,595040,125485,383735,743657,341127,207161,13643,609404,1021161,524699,866930,318607,198015,1008565,1019180,870799,397468,944807,355217,115640,4954,116126,247742,130058,553942,992948,382260,27560,751770,482999,408982,304991,800080,920378,73877,900390,813297,583688,983825,119893,581384,145193,828478,736028,341665,258171,409671,902356,929162,457288,513206,801843) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.000996s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 416068 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000365s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 416068 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000481s ]