SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001704s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 497201 LIMIT 1 [ RunTime:0.000429s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 497201 [ RunTime:0.001940s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (121513,928466,628724,783672,84387,900590,814908,738282,752030,596993,949693,705747,635683,713001,1029400,789095,160339,509885,776185,418011,264360,132275,618088,851936,986102,463018,582769,97811,421239,480123,126369,489084,579266,994106,424549,542641,165296,24052,472074,833031,967970,11944,264671,546448,548865,605041,85356,938651,517030,762040,375738,920122,464583,693704,584891,555280,724194,608687,431356,968652) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001224s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 497201 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000428s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 497201 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000893s ]