SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001210s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 539430 LIMIT 1 [ RunTime:0.000425s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 539430 [ RunTime:0.001981s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (1011986,73620,532703,164069,28188,937469,1007785,544420,8005,585902,241678,643241,546045,479578,1027460,331934,448104,415581,497958,320183,535916,196782,768464,1013587,69818,1808,984768,70487,242794,259166,720899,880166,538788,421641,387733,944777,977053,202714,515056,299648,36374,47160,903700,172380,723365,1020296,798827,316460,238636,633476,128489,960841,59506,787121,769507,102430,1042652,694638,823984,191318) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001220s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 539430 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000372s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 539430 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000692s ]