SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001261s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1003264 LIMIT 1 [ RunTime:0.001560s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1003264 [ RunTime:0.002672s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (425220,304756,918666,422377,155033,502527,494880,397710,291321,131093,618093,756420,205207,20171,60572,745208,1032427,425080,652091,309492,67172,832167,745945,989422,74589,789666,445228,887441,399014,922301,740121,498267,462994,263413,355827,448551,685150,746961,75664,868547,87203,13033,79396,704820,917661,259435,247191,56589,268542,789528,764741,864898,951722,737300,1008149,477495,344350,287296,637610,599171) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001058s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1003264 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000383s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1003264 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000425s ]