SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001431s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 470711 LIMIT 1 [ RunTime:0.000507s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 470711 [ RunTime:0.001930s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (927993,1001179,254484,655576,901824,830444,214499,615662,897783,489872,397988,354472,689418,291389,293784,401204,893872,519375,105445,681826,636423,810902,610698,52285,733440,571808,711787,422554,32075,253019,159477,538441,901568,629664,80379,162636,390668,826503,819490,444248,592839,451340,867594,936101,160240,569183,270665,1024976,985657,342462,729505,457014,193334,97793,898993,884646,362395,1026713,784273,398929) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001468s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 470711 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000381s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 470711 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000619s ]