SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.001819s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 101619 LIMIT 1 [ RunTime:0.000865s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 101619 [ RunTime:0.001649s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (55160,764426,479630,540136,459920,66769,383078,579629,240615,335862,414358,1041631,123690,1045067,389418,44567,153487,695468,656217,613313,620263,544508,724539,980138,1006490,1010256,929819,861381,629244,1026127,854383,1022500,421364,800529,544210,375303,942988,763274,148016,595079,593404,576979,16015,122468,763434,157046,136798,128844,414459,287420,820282,378905,614187,132854,573996,287594,613130,106582,848770,373582) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001039s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 101619 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000357s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 101619 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.000577s ]