SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001269s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 542502 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 542502 [ RunTime:0.001549s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (424163,645573,112828,540238,214314,857548,592623,145357,693131,471921,626798,18531,191825,400344,286639,87184,914408,33305,854052,870977,879949,365817,598696,832840,587231,522819,513251,798976,409558,1018058,1025591,156550,651086,45430,85938,402949,240434,413618,463210,94490,862316,363733,408329,217009,633967,620347,907108,602368,975144,608347,979311,574454,836108,278361,119401,189298,421148,292974,581408,766953) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001253s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 542502 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 542502 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000578s ]