SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001170s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 404779 LIMIT 1 [ RunTime:0.000332s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 404779 [ RunTime:0.001617s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (466100,816381,182734,347970,119287,1043508,351875,274929,753966,469701,290982,653368,666015,961414,807876,131994,334827,339190,68117,348885,104407,16417,353421,514963,861055,310597,1041909,295604,883920,883191,959949,501511,801406,597049,667662,1000201,686229,167106,269630,73662,223906,1027298,451129,1017770,723767,793098,1022526,201378,1042408,169092,10689,556740,464799,469127,993284,18013,345955,83409,793629,523812) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001054s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 404779 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000367s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 404779 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000598s ]