SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001466s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1008340 LIMIT 1 [ RunTime:0.000449s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1008340 [ RunTime:0.001853s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (341639,275364,572011,525022,690668,1020311,447860,916495,117198,438258,321040,703323,849958,395954,451068,568619,666909,371559,308912,394810,693275,871164,189851,565458,862356,792989,607993,852043,703955,351630,522293,759665,793087,1630,746857,349510,629551,593592,420240,976273,485986,618253,844781,715422,927570,916047,686064,947813,667139,303679,687853,661703,734443,527223,905242,978928,895233,761010,73284,599143) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001033s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1008340 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1008340 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000487s ]