SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001216s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 461621 LIMIT 1 [ RunTime:0.000327s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 461621 [ RunTime:0.002194s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (20758,48398,982946,549240,447901,1027594,930843,904172,927030,927872,354283,231757,224085,687096,481280,200471,156472,516358,58411,1040784,269683,955231,386985,353934,493219,1033746,298850,668925,375788,479036,225740,564568,194005,886274,854289,349999,779973,451312,246905,238562,645416,89686,216304,464030,187683,956459,865148,346362,106452,355784,960596,832839,913606,743655,16150,381939,580793,357170,369234,670775) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001078s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 461621 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000405s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 461621 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000724s ]