SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001428s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 108504 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 108504 [ RunTime:0.001765s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (176282,708662,104225,645048,509865,462219,94813,842262,736289,928417,194466,371375,812833,926938,782983,31592,837235,129610,543127,33859,278144,116364,602165,36564,116725,47193,354607,590733,251192,558927,152509,307918,224822,700326,142660,120906,353843,571591,555382,266008,357960,833539,325571,274738,104300,967213,815262,454665,727970,656472,684747,202910,1035247,695525,514120,500908,31098,613926,152754,60957) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001095s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 108504 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000344s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 108504 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000493s ]