SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002033s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 418152 LIMIT 1 [ RunTime:0.002358s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 418152 [ RunTime:0.002864s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (816112,778142,685753,121857,357638,949740,737993,957905,345638,617574,738045,1026331,790717,931164,175227,905316,503919,49837,595672,298543,91188,173764,919175,788619,930329,571509,564662,889971,706525,202743,957304,95781,225748,776524,188445,793944,659091,131460,771461,580473,1008547,623413,440710,29638,36010,542362,664418,868280,802432,926579,275088,115482,700345,575358,82756,111799,241730,812436,389115,788256) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002908s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 418152 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.001575s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 418152 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001603s ]