SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001164s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 290912 LIMIT 1 [ RunTime:0.000291s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 290912 [ RunTime:0.002387s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (239314,630660,382402,816682,819328,274149,363336,374895,640572,756098,411293,599477,657799,482262,959030,134806,48008,130978,336471,714380,485924,432449,537836,142298,366193,361269,724547,911435,519292,735390,755345,704985,647486,49818,642409,851306,164079,781759,239536,107886,714682,246675,1007006,292521,872230,878023,1046498,734309,12091,354083,52042,721256,40281,552853,348431,15209,796084,177688,669031,660137) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.003753s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 290912 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001270s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 290912 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000477s ]