SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001288s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 43408 LIMIT 1 [ RunTime:0.000362s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 43408 [ RunTime:0.001819s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (628035,285851,700563,497705,592928,583437,699488,739539,403700,329571,738507,752698,199440,95701,45986,719568,15684,700043,326048,172004,98461,579881,688368,152169,658915,568206,310085,440610,348812,668010,51655,309842,414002,845003,429191,1027837,178045,861264,887250,712870,276468,861122,13887,367672,778394,579669,270064,628891,443281,1024899,405010,865882,185276,1030707,765131,861699,950096,150882,82355,183906) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002194s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 43408 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 43408 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000534s ]