SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001177s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004971 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004971 [ RunTime:0.001794s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (995490,756260,48453,779700,849970,1013290,102707,1003218,649221,908154,795348,635656,1036289,336500,93010,719098,1048023,584798,875059,409534,719403,91479,774682,865867,360914,567648,932760,712662,925728,251484,57143,431439,542694,733634,80546,220789,113351,807565,942746,967254,967856,720751,144908,21595,387055,480665,72681,525708,443472,825348,961632,23488,477003,136626,365075,775221,437006,812896,723502,842433) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004971 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000385s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004971 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000462s ]