SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001614s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 552003 LIMIT 1 [ RunTime:0.000810s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 552003 [ RunTime:0.001614s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (696104,186323,849244,667904,209403,439756,233461,848687,246760,412101,193166,635863,601075,681863,968310,446021,111963,481333,443172,845988,407558,289057,632561,48186,857246,545786,233951,572417,1034439,859187,779491,453893,537897,220991,213205,779150,480090,396826,607402,332701,579717,723670,997414,208665,130875,151066,62062,836037,449216,260323,836036,329591,887281,666252,399129,772953,392231,156291,210647,22460) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001537s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 552003 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000419s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 552003 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000670s ]