SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001079s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418084 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418084 [ RunTime:0.004009s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (234155,694795,62746,768905,740105,878825,998886,1023516,416559,645618,592348,167922,674600,285251,119165,386535,393045,822975,941707,786534,554546,357291,399664,468936,363758,641732,111308,835096,650702,477422,213374,1003147,39430,16705,512327,460056,840094,987963,311499,700166,206983,255468,90794,312915,198481,321825,1010364,325253,335739,730320,964600,341981,1586,535183,492069,909401,910241,679646,329531,631438) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001214s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418084 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001108s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418084 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000966s ]