SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001201s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 474906 LIMIT 1 [ RunTime:0.000447s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 474906 [ RunTime:0.002418s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (538188,630362,1037027,364233,860040,453087,184804,51033,539671,420063,681003,108677,790246,29976,964298,533591,570123,838089,1001645,378577,1046606,47194,195602,546586,848083,672618,541635,366165,404083,993073,508771,779461,48612,437434,93167,909459,99174,233051,557409,612034,416353,737060,193152,685716,524046,1016518,484467,785776,518976,446847,597608,406321,807453,497854,370951,108186,432240,707561,954251,655431) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001115s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 474906 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000380s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 474906 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000544s ]