SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001390s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1043004 LIMIT 1 [ RunTime:0.000406s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1043004 [ RunTime:0.003107s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (548854,976856,898910,258463,146805,133094,127069,629729,439724,769461,569591,624193,468782,490985,772671,224776,69241,812764,24180,766946,389762,270095,186845,835261,22154,196320,814783,713246,624560,741972,544288,752444,965990,876584,486487,529740,140542,592517,468084,746647,811218,430613,285274,949775,74185,445479,943513,706882,511840,410578,284752,309136,478567,891148,577727,470558,718418,434278,289869,610979) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001710s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1043004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000486s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1043004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000605s ]