SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001081s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 56805 LIMIT 1 [ RunTime:0.000334s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 56805 [ RunTime:0.001635s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (989554,619471,355099,716942,691198,697952,294227,270850,731982,717165,516903,254170,368151,601886,476149,155747,456365,692565,949749,281495,866367,781790,92659,561157,252125,41230,963626,424516,1034571,1146,42186,220491,387011,372715,1039881,790869,441374,700592,598786,778217,951591,339753,145264,454778,431315,1018927,602455,104082,769978,209289,659160,263352,35402,760028,327823,135400,20677,938417,254308,56704) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001028s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 56805 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000348s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 56805 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000444s ]