SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001154s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 507259 LIMIT 1 [ RunTime:0.000377s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 507259 [ RunTime:0.001525s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (511251,130450,847907,634957,812573,480098,464405,491545,422200,627219,936204,994518,97897,837374,449209,39870,180494,156538,296339,382815,471703,925310,739957,293001,590036,451010,260301,932636,228772,898540,320986,297246,384528,265741,727789,81067,878405,758143,214561,505830,925678,482754,441317,161869,660760,50322,67218,832067,279956,439943,764783,284224,940634,947997,234534,563239,105922,914353,426165,632499) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001649s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 507259 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 507259 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001047s ]