SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001180s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 455274 LIMIT 1 [ RunTime:0.001358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 455274 [ RunTime:0.004152s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (41338,404818,349709,200568,333084,304681,1044450,518108,146218,411645,144599,466902,891830,191446,184909,815100,713129,650342,811388,691763,862728,259397,799835,867990,237437,593790,324707,884407,3199,277620,950957,20328,630110,682833,844433,113604,194178,274791,216773,579155,470257,423626,76844,508897,78584,431601,278123,709047,433920,47419,1012044,659546,911392,169486,138949,1030905,279677,873493,823201,215999) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001069s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 455274 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 455274 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000584s ]