SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001241s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1046904 LIMIT 1 [ RunTime:0.000426s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1046904 [ RunTime:0.001817s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (996271,102956,181807,839081,781243,1034144,391560,638872,735561,531011,1013733,465799,310739,892536,956803,140813,857972,312690,556617,591515,1006390,493583,840246,444105,474800,530364,457717,359559,881222,623055,602405,938333,311650,378201,210483,306932,377193,291083,152796,316545,132556,353101,1019361,502220,489250,322423,1004275,1023620,444431,97785,288838,468783,1008892,875854,465826,196746,57481,245110,1041718,974408) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002247s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1046904 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000423s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1046904 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001131s ]