SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001238s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 483184 LIMIT 1 [ RunTime:0.000379s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 483184 [ RunTime:0.003023s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (881114,366825,192946,431563,725028,776186,881044,293359,916038,56109,924601,176144,466857,505069,839955,245658,150038,478085,995356,437820,910151,158038,441613,329870,964589,974193,77580,131548,753502,448824,437870,430590,135538,846527,986778,357677,352786,670564,904376,185425,835495,430257,662449,1042426,172871,176314,725756,439222,22214,1028232,63968,57935,628559,775527,122448,546141,579862,124573,180794,441569) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001401s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 483184 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000456s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 483184 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000530s ]