SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002707s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1048511 LIMIT 1 [ RunTime:0.000374s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1048511 [ RunTime:0.004784s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (963394,969177,186204,107833,103575,543409,78402,135382,933987,136637,744083,214808,654814,34295,50189,536486,1042061,582708,994875,233494,820988,843187,882402,910717,43893,253501,703759,596189,406045,768553,892597,645034,48521,45826,338889,259675,918791,764241,700253,410163,418673,126141,133361,750064,490639,393243,569766,333093,459523,454823,70803,28578,55411,763950,142829,964633,976757,349294,824824,670683) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001426s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1048511 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1048511 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000646s ]