SHOW FULL COLUMNS FROM `tool_barcode` [ RunTime:0.002034s ]
SELECT `id`,`barcode`,`name`,`spec`,`unit`,`price`,`brand`,`supplier`,`origin` FROM `tool_barcode` WHERE `switch` = 1 AND `id` = 1004134 LIMIT 1 [ RunTime:0.000482s ]
UPDATE `tool_barcode` SET `views` = `views` + 1 WHERE `id` = 1004134 [ RunTime:0.003505s ]
SELECT `id`,`name` FROM `tool_barcode` WHERE `id` IN (824247,1016716,889832,89291,564892,936433,640390,537594,163486,1031072,715944,473399,491245,472569,195792,389302,1026171,44895,1028820,518819,876870,709932,965968,865830,247234,517811,344867,251870,690227,943810,139448,1027854,38182,821990,856702,522099,263282,745083,997109,714459,931899,810365,451810,442146,513869,276675,444549,622193,174964,172798,363658,952314,944003,884667,186172,627127,8592,740390,180126,170315) AND `switch` = 1 ORDER BY `views` DESC [ RunTime:0.001050s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` < 1004134 AND `switch` = 1 ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000359s ]
SELECT `id`,`barcode`,`name` FROM `tool_barcode` WHERE `id` > 1004134 AND `switch` = 1 ORDER BY `id` LIMIT 1 [ RunTime:0.001824s ]