SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001141s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 496410 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 496410 [ RunTime:0.001868s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (575208,943234,800176,259266,744555,414234,945818,198550,339429,961036,1008457,940893,584588,91167,735918,940939,808050,18755,712911,521519,672031,551430,272597,998521,320655,366185,142309,422227,345143,801910,153303,170298,135283,561559,384747,316404,835867,987207,370704,205894,174978,449589,293687,869304,373771,949560,807410,719840,661524,820548,739425,872964,583803,205693,661049,340207,242769,35929,921042,1001392) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001980s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 496410 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001009s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 496410 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000471s ]