SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001162s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 501491 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 501491 [ RunTime:0.002975s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (410693,756916,935837,43918,429418,150181,982475,269937,159027,170028,365432,110658,457682,33548,645855,867886,543031,434809,507781,703892,39059,733379,1206,912546,847604,879483,386330,637956,613643,583197,637846,92646,821287,762523,992119,706369,400276,953758,67587,225461,86915,850996,400575,460469,1014540,581488,55078,141911,438637,500222,600683,833585,872802,821596,683956,928557,177170,531964,861483,331805) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 501491 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000362s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 501491 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000426s ]