SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001171s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 198045 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 198045 [ RunTime:0.001811s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (129064,980754,812032,101391,276101,297821,158893,506320,175662,671360,353897,194796,519467,345474,290794,23068,463660,238724,42311,282918,812751,785633,465542,226541,541693,129128,238572,1048133,649342,837573,376829,219340,359429,603864,819503,871237,392,456349,757524,618474,287204,332920,1002548,347184,849337,315540,662548,349598,730150,809110,365441,164956,500783,1029703,779813,350265,238912,439723,924652,947153) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001006s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 198045 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000386s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 198045 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000501s ]