SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001218s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 941496 LIMIT 1 [ RunTime:0.004908s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 941496 [ RunTime:0.006194s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (294093,1042587,809770,30177,1044746,482731,981790,150256,981020,799635,1017038,364770,354436,404471,194049,710555,486510,782620,235657,383800,47828,371573,602793,148327,145491,367627,732027,687168,924832,376835,756265,823720,838597,166668,759832,748509,373991,569561,698439,798943,131008,667213,828272,117384,272897,370165,271068,695868,702768,454437,225481,573472,549303,671787,271451,73328,266111,599792,142836,43691) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001483s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 941496 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001267s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 941496 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001628s ]