SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001149s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 406686 LIMIT 1 [ RunTime:0.000354s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 406686 [ RunTime:0.002509s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (314900,561241,793314,235832,338495,416545,284150,1011109,130757,330128,282604,237454,28204,62835,487391,173880,555715,1046639,542600,407711,1032977,838264,635530,72694,670177,399261,249062,877112,694347,221857,246676,721288,31900,752277,268898,1020175,519411,740997,1026626,584044,827047,220742,802685,553128,677739,1009421,64767,538694,746958,1015430,184220,343490,24491,866727,39489,83030,909363,117197,224729,886303) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001669s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 406686 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000482s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 406686 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000494s ]