SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001163s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 44520 LIMIT 1 [ RunTime:0.000370s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 44520 [ RunTime:0.002687s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (458614,502353,979937,440047,124618,483548,698443,203331,368792,510990,622960,201768,933541,181510,679554,92087,238753,763579,324123,250757,822987,123598,565780,577811,447521,994652,821130,816033,720902,123021,213823,730200,410100,201525,572340,317481,896883,648925,669030,800321,465870,522205,395840,169185,353310,687823,450193,972651,581714,223685,245910,559430,319628,128210,423281,1022472,74499,915429,161907,363057) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001396s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 44520 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 44520 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000718s ]