SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001977s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 545458 LIMIT 1 [ RunTime:0.000450s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 545458 [ RunTime:0.003354s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (810808,918956,362628,1002344,431084,785217,306635,307965,193390,7958,743021,738048,247507,528581,876359,162211,810202,1018714,533447,1011024,499770,92714,320082,139851,894698,917691,874469,694444,437534,404165,788244,542194,1029911,396445,90420,425929,635501,467911,466406,58646,1004849,418553,715049,283084,185634,334840,66080,732803,377831,405276,674042,108717,888713,333821,325511,695098,377829,885232,575985,452453) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001123s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 545458 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 545458 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]