SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001200s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 5899 LIMIT 1 [ RunTime:0.000348s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 5899 [ RunTime:0.001566s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (728146,989091,65731,481637,77929,1023127,822008,1000939,915630,241793,775945,662509,310625,591561,319761,841274,561537,547019,453597,97547,982247,145773,616369,878760,779768,1030645,10987,429989,410883,971966,442807,478144,573404,859213,10583,1001283,87738,369241,504282,538676,833031,759930,868948,102758,854382,550519,395251,1005588,220836,498517,225498,195132,471719,742435,349117,199665,598878,30218,755110,267157) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001204s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 5899 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 5899 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000574s ]