SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002048s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 504428 LIMIT 1 [ RunTime:0.000743s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 504428 [ RunTime:0.006205s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (453948,612079,355410,201519,508119,964079,560325,410794,316972,852119,645932,817126,325409,232622,385799,259845,883022,258832,1032419,690281,804453,392065,473308,805845,269748,259696,52907,342979,124787,914361,200841,422640,248146,624631,265237,998548,181117,182181,123613,355216,315266,403477,1022476,687458,17170,938793,847461,789899,781326,614592,920145,965612,113117,147018,802192,476319,1033745,933894,330574,395794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 504428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000349s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 504428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.002135s ]