SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 389217 LIMIT 1 [ RunTime:0.002095s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 389217 [ RunTime:0.003435s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (965839,367463,197986,854155,409919,869771,136753,981287,84169,40024,784707,803644,601270,773565,1020040,921727,80426,861572,967582,1021343,889738,462380,800485,351007,404160,495733,19253,629712,112633,1007758,874869,952113,297847,353732,714746,83984,404299,503845,328653,133873,812546,152165,205660,427830,779006,52045,654419,222306,364613,404573,89183,669947,386602,1032173,957634,402265,349386,736431,747432,921409) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.002165s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 389217 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000355s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 389217 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000648s ]