SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001248s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 502614 LIMIT 1 [ RunTime:0.000393s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 502614 [ RunTime:0.001717s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (78312,189061,2424,142762,335547,460971,340822,300963,559408,41915,455162,1034387,646618,871604,402639,866654,253732,254698,871342,292041,43743,257605,183788,1011391,117503,486395,182627,354099,1030570,879381,1048798,163857,226155,551879,412313,451349,85843,996294,667939,420698,844863,375422,114642,918251,784487,143109,431429,512588,183946,935166,1035860,263953,57713,782798,767350,413183,1013394,291384,485943,828383) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001040s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 502614 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000364s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 502614 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000565s ]