SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001226s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539743 LIMIT 1 [ RunTime:0.000323s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539743 [ RunTime:0.003652s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (446498,529998,538991,514208,645744,284581,714990,298751,945555,950388,719174,996680,551443,121671,126674,338249,612869,609984,309841,495418,69527,399039,289489,396517,180960,320642,108461,208821,374044,1007047,197841,1005516,288071,624310,260386,693724,33125,431825,450128,66972,834305,793111,1030537,281282,188436,329796,348861,975170,813060,388842,603578,151072,910944,606932,496383,435274,571998,379023,521667,641891) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001851s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539743 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539743 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000591s ]