SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001272s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 478011 LIMIT 1 [ RunTime:0.000342s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 478011 [ RunTime:0.001561s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (155754,225095,405043,204488,738564,487521,698665,562501,697031,473415,83795,898195,821043,400763,195872,980034,165890,190875,192913,922629,655672,568623,12101,392002,714097,385708,822710,218633,436759,930267,482214,677002,570026,914105,39721,12860,382737,1040563,685392,828367,464454,202802,748901,825890,865260,873037,328215,67198,53660,766825,590192,236648,862683,902647,583200,486416,838410,257991,678765,925797) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 478011 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 478011 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001086s ]