SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001198s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1024095 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1024095 [ RunTime:0.002195s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (617725,481688,733939,570712,818237,428874,457943,294289,836154,669392,433447,437509,138888,755105,283428,99595,466780,853206,100955,1008115,692486,733606,300578,1020220,411634,958559,77782,666131,128348,639227,686306,514207,421174,361996,1042201,973925,30048,185335,332054,268696,244226,341814,934357,79047,715810,37534,1026669,831875,796493,380171,896550,1014482,494178,941946,655055,233026,628941,899802,51743,24021) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.026402s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1024095 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001098s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1024095 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001596s ]