SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001235s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 413292 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 413292 [ RunTime:0.001521s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (297524,831876,523744,241937,1039516,729524,838888,397871,453845,492220,325997,776476,1041515,547684,301018,410350,314563,778041,646059,176764,414501,580191,697170,824432,375571,824371,484595,1043309,413830,338002,194491,858459,100890,134241,454958,864026,208512,417132,88050,615222,394218,129370,492542,225470,422087,20103,84138,899031,853210,938055,129723,320217,857790,660177,735602,836821,335928,319202,149774,250794) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001150s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 413292 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000352s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 413292 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000660s ]