SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001231s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 568004 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 568004 [ RunTime:0.002636s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (993854,323175,988155,401837,891810,338015,943629,562904,894481,1047598,38942,158406,406689,799322,624781,171123,756700,316232,182879,183754,95846,177364,49499,206946,952296,738001,94881,1014141,257486,746705,442531,564616,109913,581663,352793,814463,812864,856217,265505,248272,1014517,997136,532034,262993,244504,1000400,747671,2957,617018,21230,596528,620393,381044,454297,72536,495901,87211,946389,130942,646167) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001178s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 568004 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000421s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 568004 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000514s ]