SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001080s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 385004 LIMIT 1 [ RunTime:0.000797s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 385004 [ RunTime:0.003448s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (147640,635564,681225,434018,785379,93150,575899,740269,498936,198751,8249,531098,243420,716628,163714,913234,679375,451904,522366,924052,476208,270586,525605,586632,268881,488431,77465,1047658,74089,348072,905386,628619,238317,278327,829014,880041,889459,912708,233707,449462,600765,675122,876805,1034597,842603,239613,365040,41967,538434,44788,445539,187082,818929,492367,557284,621563,580095,515557,419529,543475) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001855s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 385004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.004828s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 385004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000966s ]