SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001199s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1021428 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1021428 [ RunTime:0.001434s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (269336,218272,252935,874529,581354,66969,247514,393836,386103,266869,43691,374078,507323,540258,607326,622970,65539,535565,668352,1016009,175702,349314,689108,105137,734389,778608,833087,853883,702171,983243,129361,726869,310254,961343,734705,793381,322772,813036,825757,164787,260169,370809,552263,241800,64886,535807,204571,533694,580679,516055,785411,539571,51028,375955,98773,842426,510340,338140,791064,200325) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001186s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1021428 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000346s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1021428 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000548s ]