SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001924s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 547575 LIMIT 1 [ RunTime:0.000629s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 547575 [ RunTime:0.004495s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (108439,220146,435554,334598,379056,163306,135472,947054,249586,44188,602894,217398,163349,362761,962827,498865,524249,217199,476289,343505,678534,344819,436006,793063,562944,817619,773665,463545,200803,1004697,990206,744940,46600,624376,279236,540375,339141,705624,867853,880431,996745,686373,742340,375957,1008384,656740,835860,629531,647012,476060,45804,832414,467805,687330,415053,963434,457424,372608,829965,151698) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001251s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 547575 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000453s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 547575 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001565s ]