SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 685711 LIMIT 1 [ RunTime:0.000474s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 685711 [ RunTime:0.002098s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (777960,110158,472785,837002,710950,391969,386279,518943,936181,1007982,960608,628936,404592,53098,479659,626390,612127,702002,631677,298993,170991,513119,657757,330892,291473,428121,311256,424127,68933,85062,233850,171326,874495,148312,966965,824595,934202,561458,929135,541603,1021851,1048687,288135,973231,829223,620736,755235,278263,204251,908292,6248,510547,963085,1030408,403023,778333,810335,452059,660318,470537) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001594s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 685711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000498s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 685711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001209s ]