SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001093s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 268035 LIMIT 1 [ RunTime:0.000830s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 268035 [ RunTime:0.005222s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (535204,502934,155301,385716,900162,481229,83824,822246,1048061,416896,793697,16012,38057,452289,560302,173776,352058,288908,1024664,1026657,258271,182987,623901,320917,287391,83474,779876,930136,917028,138876,561179,1046235,78182,15528,436720,700528,513485,304526,811255,652715,959490,1000513,1016166,674669,65976,655006,441519,332266,47332,389554,1007292,86530,1048279,997311,207524,187610,532649,200403,386110,628748) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.012816s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 268035 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000558s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 268035 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002711s ]